{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1TA","1TB","1TC","1TD","1TE","1LA","1LB","1EA","1EB","1HA","1HB","MODELLO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1TA","index":0,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BAGGIO CRISTIAN","X","M",2003,71.599999999999994,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":{"$error":"#DIV/0!"}},"D",null,"I",null,null,6,185,544,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BARTOCCI MATTEO",null,"M",2001,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},"D",null,null,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CONTU FLAMINIA","X","F",2002,43.5,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,1,"-","-","",{"$error":"#DIV/0!"},null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DORE DENNIS",null,"M",2002,null,null,"","S",null,null,null,null,null,null,null,"Assente","",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"FALCONE SIMONE","X","M",2002,60,null,{"$error":"#DIV/0!"},"D",null,"I",null,null,-7,200,506,"",{"$error":"#DIV/0!"}]
[6,"FIORELLI LORENZO","X","M",2002,56.9,null,{"$error":"#DIV/0!"},"D",null,"S",null,null,-13,163,525,"",{"$error":"#DIV/0!"},null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"HAREB MHD ABDUL ","X","M",2001,66.2,null,{"$error":"#DIV/0!"},"D",null,"I",null,null,-6,236,466,"",{"$error":"#DIV/0!"}]
[8,"IEBBA FEDERICO","X","M",2002,66.8,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,-17,171,600,"",{"$error":"#DIV/0!"}]
[9,"INGOGLIA LUCA",null,"M",2002,null,null,"","S",null,null,null,null,null,null,null,"Assente",""]
[10,"LAPICIUS OCTAVIAN","X","M",2001,62.9,null,{"$error":"#DIV/0!"},"D",null,"S",null,null,16,209,503,"",{"$error":"#DIV/0!"}]
[11,"LORENZI MATTEO","X","M",2002,72.400000000000006,null,{"$error":"#DIV/0!"},"S",null,"S",null,null,-16,186,510,"",{"$error":"#DIV/0!"}]
[12,"MARCELLA VINCENZO","X","M",2002,67.7,null,{"$error":"#DIV/0!"},"S",null,"S",null,null,-11,212,456,"",{"$error":"#DIV/0!"}]
[13,"MONALDO FEDERICO","X","M",2002,81.900000000000006,null,{"$error":"#DIV/0!"},"D",null,"S",null,null,5,176,491,"",{"$error":"#DIV/0!"}]
[14,"PACIOTTI DANIEL",null,"M",2002,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[15,"PALERMO ANDREA","X","M",2002,53.1,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,-15,225,469,"",{"$error":"#DIV/0!"}]
[16,"PASTORIN LAWRENCE IVAN","X","M",2003,57.5,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,8,212,482,"",{"$error":"#DIV/0!"}]
[17,"RUELLO NICOLÒ",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[18,"SCIPIONI SIMONE",null,"M",2001,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[19,"SIUM MOHAMMED","X","M",2001,54.5,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,2,273,441,"",{"$error":"#DIV/0!"}]
[20,"TANARA MATTIA","X","M",2002,74.599999999999994,null,{"$error":"#DIV/0!"},"D",null,"I",null,null,7,170,535,"",{"$error":"#DIV/0!"}]
[21,"TENSI FEDERICO","X","M",2002,76.2,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,-22,"-","-","",{"$error":"#DIV/0!"}]
[22,"ULLAH JAHID",null,"M",2000,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[23,"ZANNINO FABIO","X","M",2002,71.5,null,{"$error":"#DIV/0!"},"D",null,"I",null,null,-13,166,559,"",{"$error":"#DIV/0!"}]
[24,"SOCA VALERIA",null,"F",1999,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[25,"MARCU CIOBANU","X","M",2002,92.9,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,2,173,594,"",{"$error":"#DIV/0!"}]
[26,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":26},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.65384615384615385},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.6},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":66.482352941176487},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.88235294117647056},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.11764705882352941},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.29411764705882354},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.41176470588235292},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.29411764705882354},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-4.2941176470588234},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":197.13333333333333},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":512.06666666666672}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.61538461538461542},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.94117647058823528},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.9375},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":67.918750000000003},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.3125},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.375},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.3125},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-4.625},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":197.13333333333333},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":512.06666666666672}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":3.8461538461538464E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":5.8823529411764705E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":43.5},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":1},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":17},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":16},{"$f":"MAX(O3:O32)","v":273},{"$f":"MIN(P3:P32)","v":441}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"LAPICIUS OCTAVIAN"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"SIUM MOHAMMED"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"SIUM MOHAMMED"}]

{"sheet":"1TB","index":1,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[11,8,11,9],[11,10,11,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[10,8,10,9],[10,10,10,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"CERAMICOLA KYLE",null,null,null,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CONTI ALESSIO","X","M",2002,57.6,172,19.469983775013525,"D",null,"I",null,null,-22,157,538,"","Sottopeso",null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"DAOU CARLO","X","M",2002,112.3,180,34.660493827160494,"D",null,"I",null,null,2,167,618,"","Sovrappeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DE NAPOLI MATTIA","X","M",2002,49,166,17.781971258528088,"D",null,"I",null,null,2,205,481,"","Sottopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DI PORTO DAVIDE",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[6,"DRAGOS DAVIDE MIHAI","X","M",2002,79.8,178,25.186213861886124,"D",null,"I",null,null,-12,174,507,"","Normopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"ELSADI MAGDI MAHER SARAGELDIN SKARKIA","X","M",2001,85.3,170,29.515570934256058,"D",null,"I",null,null,0,174,541,"","Sovrappeso"]
[8,"IURICH NICOLAS","X","M",2002,47.6,165,17.483930211202942,"S",null,"S",null,null,0,229,463,"","Sottopeso"]
[9,"LANZI RICCARDO","X","M",2002,55.6,168,19.699546485260775,"D",null,"I",null,null,3,230,456,"","Sottopeso"]
[10,"LIQUORI ALESSANDRO","X","M",2002,56.9,151,24.955045831323186,"D",null,"I",null,null,1,173,537,"","Normopeso"]
[11,"MAISANO","X","M",2002,62.5,171,21.37409801306385,"D",null,"I",null,null,-5,217,443,"","Normopeso"]
[12,"MALAFARINA","X","M",2001,64.3,172,21.734721471065441,"D",null,"I",null,null,-2,199,525,"","Normopeso"]
[13,"MONTELLI","X","M",2001,46.1,167,16.529814622252502,"D",null,"I",null,null,-6,160,"-","","Sottopeso"]
[14,"PERUGINI","X","M",2002,61.2,182,18.476029465040455,"D",null,"I",null,null,-25,190,469,"","Sottopeso"]
[15,"SAMORI","X","M",2002,67.599999999999994,181,20.634290772564938,"D",null,"S",null,null,-31,181,500,"","Sottopeso"]
[16,"SCANU","X","M",2002,50.6,169,17.716466510276252,"D",null,"I",null,null,2,226,490,"","Sottopeso"]
[17,"SCARANTINO","X","M",2002,73.8,173,24.658358114203612,"D",null,"I",null,null,4,198,438,"","Normopeso"]
[18,"TAMANTINO",null,"M",null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[19,"TERRACINA",null,"M",null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[20,"VASTOLA","X",null,2002,88.8,173,29.67021951952955,"D",null,"I",null,null,2,188,544,"",""]
[21,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":20},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.8},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":0.9375},{"$f":"AVERAGE(E3:E32)","v":2001.8125},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":66.1875},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":171.125},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.471672167039237},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.9375},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":6.25E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.875},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-5.4375},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":191.75},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":503.33333333333331}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.75},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.9375},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.8},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.680000000000007},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":171},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.99176901020655},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.93333333333333335},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":6.6666666666666666E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.13333333333333333},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.8666666666666667},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-5.9333333333333336},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":192},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":500.42857142857144}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":16},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":4},{"$f":"MAX(O3:O32)","v":230},{"$f":"MIN(P3:P32)","v":438}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"SCARANTINO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"LANZI RICCARDO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"SCARANTINO"}]

{"sheet":"1TC","index":2,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BUGDAY KIM EDWARD DE JESUS","X","M",2002,80.7,166,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":29.285817970677893},"D",null,"S",null,null,-9,207,535,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sovrappeso"},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CELLI MARTINA","X","F",2001,59.6,163,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":22.43215777786142},"D",null,"I",null,null,13,117,629,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CESE RICCARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente","",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"COLUCCIA DAMIANO","X","M",2002,75.3,175,24.587755102040816,"S",null,"S",null,null,8,213,414,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DAMBA AMARA","X","M",2002,58.2,167,20.868442755208147,"D",null,"S",null,null,-12,null,null,"","Normopeso"]
[6,"DI GAETANO DARIO","X","M",2003,84.4,175,27.559183673469391,"D",null,"N",null,null,-14,172,null,"","Normopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"DI TONDO LUCA","X","M",2003,65,177,20.747550193111813,"D",null,"S",null,null,0,204,493,"","Normopeso"]
[8,"DIVIZIA CLAUDIO","X","M",2003,51.3,170,17.750865051903116,"D",null,"I",null,null,2,207,580,"","Sottopeso"]
[9,"FERRANTE ROBERTO","X","M",2002,62.3,170,21.557093425605537,"D",null,"I",null,null,3,203,525,"","Normopeso"]
[10,"HOFFMANN FRANCESCO","X","M",2001,64.3,173,21.484179224163853,"D",null,"S",null,null,-9,222,468,"","Normopeso"]
[11,"IANCU LUIGI GABRIEL","X","M",2002,42.3,158,16.944399935907704,"S",null,"S",null,null,0,209,454,"","Sottopeso"]
[12,"INCELLI CRISTIAN",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[13,"LAQUINDANUM BERNARD JR JUAN","X","M",2002,47.6,161,18.363489062921953,"D",null,"I",null,null,10,244,478,"","Sottopeso"]
[14,"LATTARI ANDREA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[15,"LUPI FEDERICA",null,null,null,null,null,"",null,null,null,null,null,null,null,567,"Assente",""]
[16,"MARCHETTI LUKAS OLIVER","X","M",2001,57,174,18.826793499801823,"D",null,"N",null,null,-14,170,545,"","Sottopeso"]
[17,"MARUCCI ANDREA","X","M",2002,68.2,180,21.049382716049383,"D",null,"S",null,null,6,224,490,"","Normopeso"]
[18,"NUNZI YURI","X","M",2002,81,184,23.92485822306238,"D",null,"I",null,null,1,225,488,"","Normopeso"]
[19,"PESCETELLI MANUEL","X","M",2002,53.5,172,18.084099513250408,"D",null,"S",null,null,4,221,null,"","Sottopeso"]
[20,"PRASAD NAKUL",null,null,1999,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[21,"PUTELLI GUGLIELMO","X","M",2001,68.7,176,22.178460743801654,"D",null,"I",null,null,-4,194,null,"","Normopeso"]
[22,"SORDILLI EDOARDO","X","M",2002,64,165,23.507805325987146,"S",null,"S",null,null,1,214,515,"","Normopeso"]
[23,"VICANÒ GABRIEL",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[24,"ABBATE MARTINA MARIA","X","F",2002,55,159,21.75546853368142,"S",null,"I",null,null,-11,157,558,"","Normopeso"]
[25,"MATTEI LUCA","X","M",2002,60.5,178,19.094811261204391,"D",null,"I",null,null,2,192,502,"","Sottopeso"]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":25},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.76},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.7142857142858},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":63.1},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":170.68421052631578},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.579084946826853},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.78947368421052633},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.21052631578947367},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.47368421052631576},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.10526315789473684},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.42105263157894735},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-1.2105263157894737},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":199.72222222222223},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":511.6}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.68},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.89473684210526316},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":63.782352941176484},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":171.8235294117647},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.518528686951022},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.82352941176470584},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.17647058823529413},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.52941176470588236},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.11764705882352941},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.35294117647058826},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-1.4705882352941178},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":207.5625},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":499}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.08},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.10526315789473684},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":57.3},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":161},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":22.093813155771421},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":1},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":137},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":593.5}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":19},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":13},{"$f":"MAX(O3:O32)","v":244},{"$f":"MIN(P3:P32)","v":414}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"CELLI MARTINA"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"LAQUINDANUM BERNARD JR JUAN"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"COLUCCIA DAMIANO"}]

{"sheet":"1TD","index":3,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ALY ZYNAB MOHAM",null,"M",2001,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},"D",null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CASTILLO MARK LOUIE","X","M",2001,69.8,171,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":23.870592660989708},"D",null,"N",null,null,-2,209,490,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"COPPI MIRKO","X","M",2001,69.2,175,22.59591836734694,"D",null,"I",null,null,2,253,453,"","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DE CAPOA LUCA",null,"M",2002,null,null,"","S",null,null,null,null,null,null,null,"Assente","",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DI CONSIGLIO SAMUEL","X","M",2002,68.5,165,25.160697887970617,"D",null,"N",null,null,-16,143,560,"","Normopeso"]
[6,"FALCIANI FEDERICO","X","M",2003,50.3,169,17.611428171282519,"D",null,"S",null,null,-9,197,477,"","Sottopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"GADALLA YOUSSEF","X","M",2002,65.8,176,21.242252066115704,"S",null,"N",null,null,-11,185,500,"","Normopeso"]
[8,"GENNA MATTEO","X","M",2002,49.2,162,18.747142203932324,"D",null,"I",null,null,-9,223,491,"","Sottopeso"]
[9,"GISTI ALESSIO","X","M",2000,75.400000000000006,166,27.36246189577588,"D",null,"I",null,null,4,198,568,"","Normopeso"]
[10,"GRANDE CHRISTIAN DYLAN","X","M",2001,63.2,174,20.874620161183778,"D",null,"N",null,null,3,214,497,"","Normopeso"]
[11,"ILAGAN ZAKI HUDSON","X","M",2003,76.8,167,27.537738893470543,"D",null,"I",null,null,6,202,466,"","Normopeso"]
[12,"MEZZINI LORENZO",null,"M",2001,null,null,"","S",null,null,null,null,null,null,null,"Assente",""]
[13,"PISTOLA ANDREA","X","M",2001,56,172,18.92915089237426,"D",null,"S",null,null,18,251,466,"","Sottopeso"]
[14,"RATEANU REBECCA","X","F",2002,57.4,169,20.097335527467528,"D",null,"S",null,null,18,200,481,"","Normopeso"]
[15,"RIOTTO ROSARIO","X","M",2002,75.8,159,29.982991179146392,null,null,"N",null,null,-12,138,615,"","Sovrappeso"]
[16,"ROSSI GIACOMO",null,"M",2002,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[17,"SANTINI ALESSIO","X","M",2002,58.6,171,20.040354297048665,"D",null,"I",null,null,5,222,453,"","Sottopeso"]
[18,"TAREK HUSSEIN RAHMA",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[19,"TUCCI ROBERTO","X","M",2002,55.5,168,19.664115646258505,"D",null,"S",null,null,18,213,472,"","Sottopeso"]
[20,"URETA MUCHA WALTER","X","M",2001,59.8,163,22.507433475102562,"D",null,"N",null,null,-6,214,503,"","Normopeso"]
[21,"VENTURA FABRIZIO","X","M",2002,58.4,171,19.971957183406861,"D",null,"S",null,null,10,243,466,"","Sottopeso"]
[22,"VETTURINI MIRKO","X","M",2001,65.599999999999994,181,20.023808797045266,"D",null,"N",null,null,9,209,453,"","Sottopeso"]
[23,"VINCENTINI ORGNANI MATTEO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":23},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.73913043478260865},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.6521739130435},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":63.252941176470586},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":169.35294117647058},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.130588194465766},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.88235294117647056},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.8823529411764705E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.29411764705882354},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.41176470588235292},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.29411764705882354},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":1.6470588235294117},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":206.70588235294119},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":494.76470588235293}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.69565217391304346},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.94117647058823528},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.625},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":63.618749999999999},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":169.375},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.257666486153155},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":6.25E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.4375},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.3125},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":0.625},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":207.125},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":495.625}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":4.3478260869565216E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":5.8823529411764705E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":57.4},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":169},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.097335527467528},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":18},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":200},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":481}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":17},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":18},{"$f":"MAX(O3:O32)","v":253},{"$f":"MIN(P3:P32)","v":453}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"PISTOLA ANDREA"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"COPPI MIRKO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"COPPI MIRKO"}]

{"sheet":"1TE","index":4,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"APPOLLONI RICCARDO","X","M",2003,61.5,174,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":20.313119302417757},"D",null,"S",null,null,-24,"-","-",{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BONTEMPO FILIPPO","X","M",2002,48.6,164,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":18.069601427721597},"D",null,"I",null,null,-13,215,472,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BRANCIAMORE RICCARDO","X","M",2002,70,171,23.938989774631512,"D",null,"S",null,null,9,198,463,"","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"BRUTTI RICCARDO","X","M",2002,70,167,25.099501595611173,"D",null,"S",null,null,-17,177,540,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CALVA ALESSANDRO","X","M",2002,59.9,177,19.11966548565227,"D",null,"I",null,null,4,196,481,"","Sottopeso"]
[6,"CAPRA PIERFRANCESCO","X","M",2002,57.6,173,19.245547796451604,"D",null,"S",null,null,-10,217,460,"","Sottopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CECATI ALEX",null,"M",2002,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[8,"DE ZULIANI MIRKO","X","M",2002,95.4,177,30.451019821890259,"D",null,"I",null,null,-15,"-","-","","Sovrappeso"]
[9,"GIZZI ANDREA","X","M",2002,57.8,171,19.766765842481448,"D",null,"I",null,null,0,212,469,"","Sottopeso"]
[10,"GUARNONI LUCA",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[11,"LECCISOTTO STEFANO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[12,"MAGTIBAY JOHN KERBY VILLANUEVA","X","M",2001,53,161,20.446742023841672,"D",null,"I",null,null,-11,210,494,"","Sottopeso"]
[13,"MICHETTI LORENZO","X","M",2003,55.5,170,19.20415224913495,"D",null,"I",null,null,-3,196,509,"","Sottopeso"]
[14,"MOSCA FEDERICO","X","M",2002,66.8,167,23.952095808383234,"D",null,"S",null,null,-11,195,500,"","Normopeso"]
[15,"PARISI ANDREA","X","M",2002,82.1,175,26.808163265306121,"D",null,"S",null,null,-12,205,488,"","Normopeso"]
[16,"PARISI CHIARA","X","F",2003,57.4,158,22.993110078513055,"D",null,"I",null,null,11,164,575,"","Normopeso"]
[17,"SALOMONE MARCO","X","M",2001,54,167,19.362472659471475,"D",null,"S",null,null,7,209,478,"","Sottopeso"]
[18,"SPALLETTI MATTEO","X","M",2002,46.3,162,17.642127724432246,"D",null,"I",null,null,-12,172,529,"","Sottopeso"]
[19,"STELLA SIMONE",null,"M",2002,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[20,"TEDESCO SARIO","X","M",2002,63.2,176,20.402892561983471,"D",null,"I",null,null,-22,181,550,"","Sottopeso"]
[21,"TRIPODI ALESSIO","X","M",2002,54.5,165,20.018365472910929,"D",null,"S",null,null,12,231,438,"","Sottopeso"]
[22,"VENESELLI DANIELE","X","M",2002,53.7,171,18.364625012824462,"D",null,"I",null,null,14,228,475,"","Sottopeso"]
[23,"ASCENCIO APAZA PAUL ANTHONY",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[24,"BERTOLOTTI FABIO","X","M",2001,44.5,162,16.956256668190822,"D",null,"I",null,null,-8,183,528,"","Sottopeso"]
[25,"MORANTE GABRIEL","X","M",2001,62.6,168,22.179705215419506,"D",null,"S",null,null,-20,219,482,"","Normopeso"]
[26,"PORCARI GABRIELE",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[27,"ZIOMKA JAKUB","X","M",2002,62.3,175,20.342857142857142,"D",null,"S",null,null,3,235,472,"","Sottopeso"]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":27},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.77777777777777779},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.7777777777778},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":60.795238095238084},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":169.0952380952381},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.175132234767936},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.47619047619047616},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.52380952380952384},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-5.6190476190476186},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":202.26315789473685},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":494.89473684210526}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.7407407407407407},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.95238095238095233},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.9},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":60.964999999999989},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":169.65},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.084233342580681},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-6.45},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":204.38888888888889},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":490.44444444444446}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":3.7037037037037035E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":4.7619047619047616E-2},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2003},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":57.4},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":158},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":22.993110078513055},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":11},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":164},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":575}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":21},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":14},{"$f":"MAX(O3:O32)","v":235},{"$f":"MIN(P3:P32)","v":438}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"VENESELLI DANIELE"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"ZIOMKA JAKUB"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"TRIPODI ALESSIO"}]

{"sheet":"1LA","index":5,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ASTROLOGO ANGELO",null,null,null,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BERNABE DONALINE",null,null,null,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BIANCHI ALESSANDRO","X","M",2001,73.5,172,24.844510546241214,"D",null,"S",null,null,"-","-","-","","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CALO' REBECCA","X","F",2003,63.9,157,25.92397257495233,"D",null,"I",null,null,-19,117,653,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CAPONE ANDREA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[6,"COLASANTI DAMIANO","X","M",2002,65.2,170,22.560553633217996,"D",null,"S",null,null,6,202,478,"","Normopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CRISTIANI LORENZO","X","M",2002,51.5,161,19.868060645808416,"D",null,"S",null,null,6,197,481,"","Sottopeso"]
[8,"D'ALO' LORENZO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[9,"D'ATTINO EDOARDO","X","M",2002,52.4,166,19.015822325446365,"D",null,"S",null,null,-1,208,522,"","Sottopeso"]
[10,"FANELLI PIETRO","X","M",2002,57.1,172,19.300973499188753,"D",null,"I",null,null,0,202,510,"","Sottopeso"]
[11,"GAGLIARDINI DAVIDE","X","M",2002,58.9,168,20.868764172335602,"D",null,"S",null,null,9,208,471,"","Normopeso"]
[12,"GROSSI SALVATORE","X","M",2002,55.8,169,19.537131052834287,"D",null,"I",null,null,-15,192,484,"","Sottopeso"]
[13,"MAGGI GIORGIA","X","F",2002,52.3,166,18.97953258818406,"D",null,"S",null,null,-5,171,531,"","Sottopeso"]
[14,"NAPPI GIULIO","X","M",2003,47.3,159,18.709702938966018,"D",null,"S",null,null,-20,180,553,"","Sottopeso"]
[15,"ORSOLA RICCARDO","X","M",2002,51.5,161,19.868060645808416,"D",null,"I",null,null,-18,134,640,"","Sottopeso"]
[16,"PICHINI LEONARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[17,"SANGERMANO ANDREA","X","M",2003,57.6,169,20.167361086796685,"D",null,"S",null,null,0,200,478,"","Sottopeso"]
[18,"SANTOPADRE LEONARDO","X","M",2002,73.3,167,26.282763813689986,"S",null,"I",null,null,-17,166,"-","","Normopeso"]
[19,"SCAFETTA LETIZIA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[20,"SENTINELLI TOMMASO","X","M",2001,59.7,168,21.152210884353746,"D",null,"S",null,null,-10,170,535,"","Normopeso"]
[21,"FALASCA FEDERICO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[22,"MALGIERI MATTIA",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[23,"OLIVO PAOLO","X","M",2002,73.7,173,24.624945704834776,"D",null,"I",null,null,-25,168,613,"","Normopeso"]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":23},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.65217391304347827},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2002.0666666666666},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":59.580000000000005},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.53333333333333},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.44695774084391},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.93333333333333335},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":6.6666666666666666E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.6},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.4},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-7.7857142857142856},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":179.64285714285714},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":534.53846153846155}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.56521739130434778},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.8666666666666667},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":59.807692307692314},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.30769230769232},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.292373919194024},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.92307692307692313},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":7.6923076923076927E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.61538461538461542},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.38461538461538464},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-7.083333333333333},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":185.58333333333334},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":524.09090909090912}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":8.6956521739130432E-2},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.13333333333333333},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":58.099999999999994},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":161.5},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":22.451752581568194},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.5},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-12},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":144},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":592}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":15},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":9},{"$f":"MAX(O3:O32)","v":208},{"$f":"MIN(P3:P32)","v":471}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"GAGLIARDINI DAVIDE"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"D'ATTINO EDOARDO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"GAGLIARDINI DAVIDE"}]

{"sheet":"1LB","index":6,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BELLONI VITTORIO","X","M",2002,50.6,163,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":19.044751402009862},"D",null,"S",null,null,-10,162,531,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BERNABE","X","F",2002,50.7,158,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":20.309245313251079},"D",null,"N",null,null,-8,150,615,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BRUGNOLI","X","M",2002,57.9,159,22.902575056366437,"D",null,"N",null,null,-14,164,550,"","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CANTONE","X","M",2002,64,171,21.887076365377382,"D",null,"I",null,null,10,214,460,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CAPORALI",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[6,"CHITI","X","M",2002,70.3,172,23.762844780962684,"D",null,"S",null,null,0,"-","-","","Normopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"COEN",null,"M",2001,null,null,"","D",null,"I",null,null,null,null,null,"Assente",""]
[8,"D’ALESSANDRO","X","F",2002,61.8,172,20.889670091941593,"D",null,"I",null,null,26,167,563,"","Normopeso"]
[9,"DE VINCENZI","X","M",2002,81.5,177,26.014236011363273,"D",null,"S",null,null,-3,200,475,"","Normopeso"]
[10,"EMIGLI","X","M",2001,63.8,177,20.364518497238976,"D",null,"S",null,null,-22,186,466,"","Sottopeso"]
[11,"FIORETTO","X","M",2002,53.9,163,20.286800406488766,"D",null,"I",null,null,-7,168,550,"","Sottopeso"]
[12,"GASPARRI",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[13,"MANGIONE","X","M",2003,41.5,159,16.415489893595979,"D",null,"I",null,null,-23,141,650,"","Sottopeso"]
[14,"MELITO","X","F",2002,59.4,156,24.408284023668635,"D",null,"I",null,null,5,138,552,"","Normopeso"]
[15,"MINNEI",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[16,"NURUL",null,"F",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[17,"PERONI","X","F",2002,42.9,155,17.856399583766908,"D",null,"I",null,null,25,"-",573,"","Sottopeso"]
[18,"RENCRICCA","X","M",2003,62.3,163,23.448379690616886,"D",null,"S",null,null,1,188,524,"","Normopeso"]
[19,"ROMEO","X","M",2002,48.8,161,18.826434165348555,"D",null,"S",null,null,9,205,"-","","Sottopeso"]
[20,"RULLO",null,"M",2003,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[21,"BARTOLLI","X","M",2001,69.099999999999994,176,22.30759297520661,null,null,"S",null,null,-8,227,425,"","Normopeso"]
[22,"CANTADORI",null,null,2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[23,"DI MICHELE","X","M",2002,71.7,175,23.412244897959184,null,null,"S",null,null,-4,228,564,"","Normopeso"]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":24},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.66666666666666663},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.8260869565217},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":59.387499999999996},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":166.0625},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.383533947197673},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.375},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-1.4375},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":181.28571428571428},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":535.57142857142856}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.5},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.75},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":61.283333333333331},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":168},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.556078678544548},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.83333333333333337},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.66666666666666663},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":8.3333333333333329E-2},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.25},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-5.916666666666667},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":189.36363636363637},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":519.5}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.16666666666666666},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.25},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":53.7},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":160.25},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.865899753157052},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.75},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":12},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":151.66666666666666},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":575.75}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":16},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":26},{"$f":"MAX(O3:O32)","v":228},{"$f":"MIN(P3:P32)","v":425}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"D’ALESSANDRO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"DI MICHELE"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"BARTOLLI"}]

{"sheet":"1EA","index":7,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BECCHERLE MARIA SOLE","X","F",2003,52.2,157,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":21.177329709115988},"D",null,"I",null,null,-10,150,556,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BIANCHI MATTEO","X","M",2002,82.8,165,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":30.41322314049587},"D",null,"N",null,null,-7,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sovrappeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BONGINI RICCARDO","X","M",2002,77.7,180,23.981481481481481,"D",null,"S",null,null,-13,null,null,"","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"BONTOI GIORGIIO","X","M",2001,65.900000000000006,178,20.799141522535034,"S",null,"I",null,null,-10,242,469,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CAPIZZI SERGIO","X","M",2002,68.5,168,24.270124716553291,"D",null,"S",null,null,15,162,510,"","Normopeso"]
[6,"CARDONE EMANUELE","X","M",2002,52.5,172,17.746078961600865,"D",null,"I",null,null,-19,null,null,"","Sottopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CATALANO LORENZO","X","M",2002,56.8,174,18.760734575241113,"D",null,"S",null,null,-15,217,471,"","Sottopeso"]
[8,"CATALETA MARCO","X","M",2002,81.099999999999994,167,29.079565420058085,"D",null,"N",null,null,-24,153,565,"","Sovrappeso"]
[9,"COCCIA VALERIO","X","M",2002,53.9,163,20.286800406488766,"D",null,"S",null,null,0,175,547,"","Sottopeso"]
[10,"CUOMO GIULIA","X","F",2002,52.2,152,22.593490304709142,"D",null,"S",null,null,11,152,578,"","Normopeso"]
[11,"DI FILIPPO GIACOMO","X","M",2002,49.8,166,18.072289156626507,"D",null,"I",null,null,-25,187,488,"","Sottopeso"]
[12,"D'UBALDO MAX",null,null,2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[13,"ESPOSTO MANUEL ANTONIO","X","M",2000,47,173,15.703832403354605,"D",null,"N",null,null,-2,187,485,"","Sottopeso"]
[14,"FANFONI ILARIA",null,null,1998,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[15,"FREZZA MIRKO",null,null,2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[16,"GIANFELICI BEATRICE","X","F",2002,51.4,167,18.430205457348777,"D",null,"S",null,null,18,202,487,"","Sottopeso"]
[17,"LEMBO PIERLUIGI","X","M",2002,74.5,171,25.477924831572111,"D",null,"I",null,null,-6,164,553,"","Normopeso"]
[18,"OTTAVIANI VALERIA","X","F",2002,43.2,158,17.304919083480211,"D",null,"S",null,null,1,147,550,"","Sottopeso"]
[19,"PAZ ANGELLA YVETTE","X","F",2001,45.8,148,20.909422936449964,"D",null,"S",null,null,15,210,557,"","Normopeso"]
[20,"PERINOTTO DAMIANO","X","M",2002,67.8,181,20.695338970116907,"D",null,"I",null,null,-6,null,null,"","Sottopeso"]
[21,"VETTURINI MANUEL","X","M",2002,61.1,171,20.895318217571223,"D",null,"I",null,null,-9,null,null,"","Normopeso"]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":21},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.8571428571428571},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.5714285714287},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":60.23333333333332},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":167.27777777777777},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":21.477623405266669},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94444444444444442},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.5555555555555552E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.44444444444444442},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.16666666666666666},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.3888888888888889},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-4.7777777777777777},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":180.61538461538461},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":524.30769230769226}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.61904761904761907},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.72222222222222221},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.7692307692307},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":64.569230769230757},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":171.46153846153845},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.013988754130448},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.92307692307692313},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":7.6923076923076927E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.30769230769230771},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.23076923076923078},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.46153846153846156},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-9.3076923076923084},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":185.875},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":511}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.19047619047619047},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.27777777777777779},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2002},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":48.96},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":156.4},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":20.08307349822082},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.8},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.2},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":7},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":172.2},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":545.6}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":18},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":18},{"$f":"MAX(O3:O32)","v":242},{"$f":"MIN(P3:P32)","v":469}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"GIANFELICI BEATRICE"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"BONTOI GIORGIIO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"BONTOI GIORGIIO"}]

{"sheet":"1EB","index":8,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"BARBERIS GIULIA",null,"F",2002,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"CARDILLI LAVINIA","X","F",2002,51,163,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":19.195302796492154},"D",null,"S",null,null,-13,"-","-",{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Normopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"CHIERICONI ANDREADANTE","X","M",2002,52,169,18.206645425580341,"D",null,"N",null,null,-32,191,491,"","Sottopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"CLEMENTI MARCO","X","M",2002,61.5,167,22.051704973286959,"D",null,"S",null,null,13,245,463,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CONTINI JACOPO","X","M",2003,60.3,166,21.88271156916824,"D",null,"S",null,null,-2,200,471,"","Normopeso"]
[6,"D'ALENA VLADIMIR","X","M",2001,41.4,156,17.011834319526624,"D",null,"S",null,null,-8,194,544,"","Sottopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"DE TORRES ARTHIANN","X","M",2000,64,178,20.199469763918696,"D",null,"N",null,null,-21,197,528,"","Sottopeso"]
[8,"DI NEPI SAUL","X","M",2001,67.5,163,25.405547818886674,"D",null,"S",null,null,-27,138,663,"","Normopeso"]
[9,"FALASCA MICHELA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[10,"GUANZON JESTEN","X","F",2001,61.8,151,27.10407438270251,"D",null,"N",null,null,-21,152,656,"","Normopeso"]
[11,"HERNANDEZ INGRID",null,"M",1997,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[12,"MANALO KRISTINE","X","M",2002,38.700000000000003,143,18.925130813242706,"D",null,"N",null,null,-18,196,528,"","Sottopeso"]
[13,"MARZIALE LUDOVICO","X","M",2002,71.599999999999994,171,24.486166683765944,"D",null,"S",null,null,9,209,472,"","Normopeso"]
[14,"MATTIACCI FEDERICO","X","M",2002,77.5,174,25.597833267274407,"D",null,"S",null,null,6,213,440,"","Normopeso"]
[15,"MELONI SABRINA",null,"F",2001,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[16,"MORETTI GIULIA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[17,"PAULE GENE ANGELO",null,"M",1997,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[18,"PIETROLATI RICCARDO","X","M",2002,77.3,179,24.125339408882368,"D",null,"S",null,null,12,221,475,"","Normopeso"]
[19,"POGGESI ROBERTA","X","F",2001,49.5,150,22,"D",null,"N",null,null,5,139,656,"","Normopeso"]
[20,"PRUNESTI' COSTANTINO","X","M",2001,65,178,20.515086478979924,"D",null,"N",null,null,19,261,446,"","Sottopeso"]
[21,"RAINALDI FRANCESCO","X","M",2002,62.1,167,22.2668435583922,"D",null,"S",null,null,4,198,495,"","Normopeso"]
[22,"RIPANI LETIZIA","X","F",2002,52.2,159,20.647917408330365,"S",null,"S",null,null,10,155,544,"","Normopeso"]
[23,"SONNINO ANGELO",null,"M",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[24,"VALENTINI ANDREA","X","M",2001,52.9,164,19.668352171326593,"D",null,"S",null,null,16,247,462,"","Sottopeso"]
[25,"SHAMMI SHAELA","X","F",2002,82,156,33.694937541091385,"D",null,"N",null,null,-11,92,734,"","Sovrappeso"]
[26,"VACCARI CHIARA",null,null,2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":26},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.69230769230769229},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.1923076923076},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":60.461111111111109},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":164.11111111111111},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":22.388049910047119},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.94444444444444442},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":5.5555555555555552E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.61111111111111116},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.3888888888888889},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":-3.2777777777777777},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":191.05882352941177},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":533.41176470588232}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.5},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.72222222222222221},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.6153846153845},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":60.907692307692301},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":167.30769230769232},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":21.564820480940902},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.69230769230769229},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.30769230769230771},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-2.2307692307692308},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":208.46153846153845},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":498.30769230769232}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.19230769230769232},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.27777777777777779},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.6},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":59.3},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":155.80000000000001},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":24.528446425723281},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.8},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.4},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.6},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":-6},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":134.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":647.5}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":18},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":19},{"$f":"MAX(O3:O32)","v":261},{"$f":"MIN(P3:P32)","v":440}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"PRUNESTI' COSTANTINO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"PRUNESTI' COSTANTINO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"MATTIACCI FEDERICO"}]

{"sheet":"1HA","index":9,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ABD EL MALAK ANGELA HANY YACOUBHI ","X","F",2002,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":{"$error":"#DIV/0!"}},"D",null,"I",null,null,-7,149,687,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"BARRECA BENEDETTA",null,"F",2002,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},"D",null,"I",null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":"Assente"},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BONIZIO ELISA ","X","F",2002,49.2,156,20.216962524654832,"D",null,"I",null,null,17,142,570,"","Normopeso",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"DE STEFANO SALVATORE","X","M",2001,65.599999999999994,161,25.307665599321009,"D",null,"S",null,null,-5,132,603,"","Normopeso",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"DI TERLIZZI ARIANNA ","X","F",2002,51,160,19.921874999999996,"D",null,"S",null,null,0,167,518,"","Normopeso"]
[6,"FARRO IYCEE ROSE CASTILLO","X","F",2002,50.7,159,20.054586448320872,"D",null,"N",null,null,2,176,581,"","Normopeso",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"GALUPPI RICCARDO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[8,"GUILLEN FAJARDO SANTIAGO JOSUE",null,"M",1999,null,null,"","S",null,"I",null,null,null,null,null,"Assente",""]
[9,"HABIB EISSA PAOLO",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[10,"HOWLADAR RABBI","X","M",2001,60.8,168,21.541950113378686,"D",null,"S",null,null,-5,215,null,"","Normopeso"]
[11,"LUONGO KEVIN",null,null,2001,null,null,"","S",null,"S",null,null,null,null,null,"Assente",""]
[12,"MARIANI VALERIO","X","M",2002,null,null,{"$error":"#DIV/0!"},"D",null,"N",null,null,null,165,610,"",{"$error":"#DIV/0!"}]
[13,"MATURANA RIVADERA SARA NICOLE","X","F",2001,67,165,24.609733700642796,"D",null,"I",null,null,9,156,587,"","Normopeso"]
[14,"MELIS NADIN","X","F",2002,54.4,157,22.069860846281795,"D",null,"S",null,null,-10,152,562,"","Normopeso"]
[15,"MONTRONE CLARA",null,null,null,null,null,"","D",null,null,null,null,null,null,null,"Assente",""]
[16,"PERUGINI GAIA","X","F",2003,53.3,162,20.309404054260018,"D",null,"S",null,null,18,157,593,"","Normopeso"]
[17,"RICCI FLAVIO","X","M",2002,59.3,172,20.044618712817741,"D",null,"S",null,null,-12,206,459,"","Sottopeso"]
[18,"SGRULLETTI BEATRICE","X","F",2002,57.6,160,22.499999999999996,"D",null,"S",null,null,11,173,550,"","Normopeso"]
[19,"STANICI EMANUELE","X","M",2002,49.9,168,17.679988662131521,"D",null,"S",null,null,3,191,516,"","Sottopeso"]
[20,"TROVATO JACOPO","X","M",2002,69.2,177,22.08816112866673,"D",null,"I",null,null,-17,182,544,"","Normopeso"]
[21,"VALATOVICH DARYA","X","F",2002,59.2,171,20.245545637974079,"S",null,"N",null,null,14,144,600,"","Normopeso"]
[22,"VIVO GEYZEFF REI","X","F",2002,50.4,156,20.710059171597631,"D",null,"N",null,null,1,144,603,"","Normopeso"]
[23,"YUZON KIMBERLY JOI CORRAI","X","F",2001,61.3,159,24.247458565721288,null,null,"I",null,null,3,191,531,"","Normopeso"]
[24,"POP MALINA","X","F",2000,63,159,24.919900320398717,"D",null,"N",null,null,11,163,571,"","Normopeso"]
[25,"RANIACCI",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[26,"TAREK",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[27,"VERNIA ANDREA","X","M",2000,65.599999999999994,174,21.667327255912273,"D",null,"S",null,null,4,244,447,"","Normopeso"]
[28,"HASSAN MOANUL","X","M",null,71.5,175,23.346938775510203,null,null,null,null,null,-11,181,565,"","Normopeso"]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":28},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.7142857142857143},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.5},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":58.833333333333336},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":164.38888888888889},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.85},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.05},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.45},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":1.368421052631579},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":171.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":563}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.2857142857142857},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.4},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.4285714285713},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":63.128571428571426},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":170.71428571428572},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.625},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.125},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":-6.1428571428571432},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":189.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":534.85714285714289}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.39285714285714285},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.6},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.75},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":56.1},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":160.36363636363637},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.83333333333333337},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":8.3333333333333329E-2},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.33333333333333331},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":5.75},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":159.5},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":579.41666666666663}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":20},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":18},{"$f":"MAX(O3:O32)","v":244},{"$f":"MIN(P3:P32)","v":447}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"PERUGINI GAIA"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"VERNIA ANDREA"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"VERNIA ANDREA"}]

{"sheet":"1HB","index":10,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[27,8,27,9],[27,10,27,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[24,8,24,9],[24,10,24,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[15,8,15,9],[15,10,15,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[12,8,12,9],[12,10,12,12],[9,8,9,9],[9,10,9,12],[5,8,5,9],[5,10,5,12],[5,22,5,23],[6,8,6,9],[6,10,6,12],[6,22,6,23],[7,8,7,9],[7,10,7,12],[7,21,8,24],[8,8,8,9],[8,10,8,12],[3,8,3,9],[3,10,3,12],[3,22,3,23],[4,8,4,9],[4,10,4,12],[4,22,4,23],[2,8,2,9],[2,10,2,12],[2,22,2,23],[0,0,0,18],[0,21,0,24],[1,8,1,9],[1,10,1,12],[1,22,1,23]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,"ALLOCCA CLARA","X","F",2001,43.4,154,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":18.299881936245573},"D",null,"N",null,null,9,193,529,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,"AMORI MARCELLO","X","M",2002,53.9,172,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":18.219307733910224},"D",null,"I",null,null,0,193,490,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":"Sottopeso"},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,"BALBOA JULLETTA",null,"F",2001,null,156,"","S",null,"N",null,null,5,142,597,"Assente","",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,"BIGETTI GIULIA",null,"F",2003,null,null,"",null,null,null,null,null,null,null,null,"Assente","",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,"CASINI NICOLO'","X","M",2002,71.5,172,24.168469442942133,"D",null,"I",null,null,2,202,471,"","Normopeso"]
[6,"CHAVEZ OBILITAS",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente","",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,"CHIARADONNA LUDOVICA","X","F",2002,63.6,177,20.300679881260173,"D",null,"N",null,null,1,150,553,"","Normopeso"]
[8,"DE VINCENTI SARA",null,"F",2001,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[9,"DI IACOVO UMBERTO",null,"M",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[10,"EBAID MIRA","X","F",2002,71.099999999999994,158,28.48101265822784,"S",null,"N",null,null,6,110,628,"","Sovrappeso"]
[11,"FURCINTI MARIA LAURA",null,"F",2002,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[12,"GRANDE CHRISTIAN ",null,"M",1998,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[13,"GUANZON MAHR","X","F",2000,53.3,150,23.688888888888886,"D",null,"N",null,null,3,160,616,"","Normopeso"]
[14,"LEUZZI MARCANTONIO","X","M",2002,61.4,167,22.015848542436085,"D",null,"I",null,null,-8,182,506,"","Normopeso"]
[15,"MUCCI ALESSIO",null,"M",2000,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[16,"MARTINEZ CHAMUL DAYANA","X","F",2000,48.4,158,19.387918602788012,"D",null,"S",null,null,8,159,568,"","Normopeso"]
[17,"OLARASU RAMONA ","X","F",2001,53,157,21.501886486267189,"D",null,"N",null,null,0,141,609,"","Normopeso"]
[18,"PACIONI ELEONORA","X","F",2002,55.3,172,18.692536506219579,"D",null,"S",null,null,-4,177,481,"","Sottopeso"]
[19,"PAOLUCCI ALESSIA","X","F",2002,null,159,0,"S",null,"N",null,null,-3,null,null,"","Sottopeso"]
[20,"ROSSI EDOARDO FRANCESCO","X","M",2002,73.900000000000006,176,23.85717975206612,"D",null,"I",null,null,0,176,503,"","Normopeso"]
[21,"SOCA THOMAS VALERINE",null,"M",1999,null,null,"",null,null,null,null,null,null,null,null,"Assente",""]
[22,"SOFFIATINI CLAUDIO","X","M",2001,96.3,184,28.44399810964083,"D",null,"N",null,null,-9,null,null,"","Sovrappeso"]
[23,"SPIZZICHINI DAVIDE ","X","M",2002,56.2,164,20.895300416418802,"D",null,"S",null,null,5,184,483,"","Normopeso"]
[24,"YOWAKIM GASMAN FAHMY","X","F",2002,56.7,165,20.826446280991739,"D",null,"N",null,null,9,140,580,"","Normopeso"]
[25,"CARIN GIANCARLO","X","M",null,59,163,22.206330686137981,"D",null,"S",null,null,10,225,481,"","Normopeso"]
[26,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":26},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":0.61538461538461542},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":1},{"$f":"AVERAGE(E3:E32)","v":2001.25},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":61.133333333333326},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":165.5},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":20.686605370277569},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":0.875},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":0.125},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":0.5},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":0.25},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":1.8125},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":170.85714285714286},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":535.57142857142856}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":0.26923076923076922},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":0.4375},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":2001.8333333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":67.45714285714287},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":171.14285714285714},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":22.829490669078883},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":1},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.2857142857142857},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.14285714285714285},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":0.5714285714285714},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":0},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":193.66666666666666},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":489}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":0.30769230769230771},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":0.5625},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":2001.3333333333333},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":55.599999999999994},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":161.11111111111111},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":19.019916804543222},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.77777777777777779},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.22222222222222221},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.22222222222222221},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0.77777777777777779},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":0},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":3.2222222222222223},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":153.75},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":570.5}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":16},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":10},{"$f":"MAX(O3:O32)","v":225},{"$f":"MIN(P3:P32)","v":471}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":"CARIN GIANCARLO"},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":"CARIN GIANCARLO"},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":"CASINI NICOLO'"}]

{"sheet":"MODELLO","index":11,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,22,5,23],[6,22,6,23],[7,21,8,24],[0,21,0,24],[1,22,1,23],[2,22,2,23],[3,22,3,23],[4,22,4,23],[27,8,27,9],[27,10,27,12],[31,8,31,9],[31,10,31,12],[38,13,38,15],[28,8,28,9],[28,10,28,12],[29,8,29,9],[29,10,29,12],[30,8,30,9],[30,10,30,12],[24,8,24,9],[24,10,24,12],[25,8,25,9],[25,10,25,12],[26,8,26,9],[26,10,26,12],[21,8,21,9],[21,10,21,12],[22,8,22,9],[22,10,22,12],[23,8,23,9],[23,10,23,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12],[20,8,20,9],[20,10,20,12],[15,8,15,9],[15,10,15,12],[16,8,16,9],[16,10,16,12],[17,8,17,9],[17,10,17,12],[12,8,12,9],[12,10,12,12],[13,8,13,9],[13,10,13,12],[14,8,14,9],[14,10,14,12],[9,8,9,9],[9,10,9,12],[10,8,10,9],[10,10,10,12],[11,8,11,9],[11,10,11,12],[6,8,6,9],[6,10,6,12],[7,8,7,9],[7,10,7,12],[8,8,8,9],[8,10,8,12],[0,0,0,18],[4,8,4,9],[4,10,4,12],[5,8,5,9],[5,10,5,12],[3,8,3,9],[3,10,3,12],[1,8,1,9],[1,10,1,12],[2,8,2,9],[2,10,2,12]]}
["MODELLO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["N°","Alunno","Presente","Sex","Anno","Peso","Statura","BMI","S/D",null,"S/N/I",null,null,"Flessibilità","Ldf","Velocità","Note",null,"Sport",null,null,"COLONNA","FUNZIONE",null,"SIMBOLO"]
[1,null,null,null,null,null,null,{"$f":"IF(C3 = \"X\",F3/(G3/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C3<>\"X\",B3<>\"\"),\"Assente\",IF(AND(B3=\"\",C3=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C3=\"X\",D3=\"M\"),IF(H3<>\"\",IF(H3<20.7,\"Sottopeso\",IF(H3>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C3=\"X\",D3=\"F\"),IF(H3<>\"\",IF(H3<19.1,\"Sottopeso\",IF(H3>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"I-J","MANCINO O DESTRO ",null,"S/D"]
[2,null,null,null,null,null,null,{"$f":"IF(C4 = \"X\",F4/(G4/100)^2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(C4<>\"X\",B4<>\"\"),\"Assente\",IF(AND(B4=\"\",C4=\"X\"),\"??\",\"\"))","v":""},{"$f":"IF(AND(C4=\"X\",D4=\"M\"),IF(H4<>\"\",IF(H4<20.7,\"Sottopeso\",IF(H4>27.8,\"Sovrappeso\",\"Normopeso\")),\"\"),IF(AND(C4=\"X\",D4=\"F\"),IF(H4<>\"\",IF(H4<19.1,\"Sottopeso\",IF(H4>27.3,\"Sovrappeso\",\"Normopeso\")),\"\"),\"\"))","v":""},null,null,null,"K-L-M","SPORTIVO - NON SPORTIVO - INTERMEDIO",null,"S/N/I"]
[3,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"","",null,null,null,"O","SALTO IN LUNGO DA FERMO",null,"NUMERICO"]
[4,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"","",null,null,null,"SPORT","ALUNNO SELEZIONATO PER SQUADRA",null,"X"]
[5,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"","",null,null,null,"TUTTI I DATI VANNO INSERITI IN FORMATO CAPSLOCK (MAIUSCOLO)"]
[7,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[8,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[9,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[10,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[11,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[12,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[13,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[14,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[16,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[17,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[18,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[20,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[21,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[22,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[23,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[24,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,"",""]
[]
[]
[null,"Alunni :",{"$f":"COUNTIF(B3:B32,\"<>\"&\"\")","v":0},null,null,null,null,null,"D","S","S","N","I"]
[null,"Media",{"$f":"COUNTIF(C3:C32,\"X\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")+COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E3:E32)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\")/C39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\")","v":{"$error":"#DIV/0!"}}]
[null,"Media maschi",{"$f":"COUNTIFS(C3:C32,\"X\",D3:D32,\"M\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"M\",C3:C32,\"X\")/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"M\")/COUNTIFS(D3:D32,\"M\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"M\")","v":{"$error":"#DIV/0!"}}]
[null,"Media femmine",{"$f":"COUNTIFS(C4:C32,\"X\",D4:D32,\"F\")/C35","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIFS(D3:D32,\"F\",C3:C32,\"X\")/C39","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(E3:E32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(F3:F32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(G3:G32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(H3:H32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"D\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(I3:I32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"S\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"N\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"(COUNTIFS(K3:K32,\"I\",C3:C32,\"X\",D3:D32,\"F\")/COUNTIFS(D3:D32,\"F\",C3:C32,\"X\"))","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(N3:N32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(O3:O32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIFS(P3:P32,C3:C32,\"X\",D3:D32,\"F\")","v":{"$error":"#DIV/0!"}}]
[null,"Presenti",{"$f":"COUNTIF(C3:C32,\"X\")","v":0},null,null,null,null,null,null,null,null,null,null,"Record"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N3:N32)","v":0},{"$f":"MAX(O3:O32)","v":0},{"$f":"MIN(P3:P32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(B3:B32,MATCH(N40,N3:N32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(O40,O3:O32,0),1)","v":{"$error":"#N/A"}},{"$f":"INDEX(B3:B32,MATCH(P40,P3:P32,0),1)","v":{"$error":"#N/A"}}]